10. Curing Bobby Tables
Curing Bobby Tables - Intro to Relational Databases
At the end, the video says to press "Submit". That's for an older version of this quiz. Instead, just complete this checklist —
Task Description:
Update the forum code to be safe against the SQL injection attack. Check your work by writing forum posts that contain single quotes. Also check that the attack message doesn't delete the forum any more.
Task Feedback:
Great! Take a look at the next video for one way to do this.
Solution:
Ud197 RDB REDO L3 11S Curing Bobby Tables SOLUTION
By the way, the warnings about using %
with SQL statements and user data also apply to newer ways of doing string formatting in Python. This includes f-strings, introduced in Python 3.6.